| |
320 Search Results Found |
| 1 |
Forum: Server Administration «»
Posted on: Tue, 12 February 2019 08:34 «»
By: wtolentino
Re: How To Get the username that is currently Proxy To
…so much saw some that might help. then found the dba_audit_trail might help with the use of column action_name = 'PROXY AUTHENTICATION ONLY'. from that table there is a column sessionid where can I link this column to other tables that might help me get …
|
| 2 |
Forum: Security «»
Posted on: Mon, 05 November 2018 06:47 «»
By: muthukrish104
Who locked oracle user
…Everyone,
I want to know who locked the account.
Our parameter setup is:-
audit_file_dest string C:\ORACLE\ORA12C\HOME\DBS\ADMIN\ADUMP
audit_sys_operations boolean…
|
| 3 |
Forum: Forms «»
Posted on: Thu, 30 August 2018 01:53 «»
By: glmjoy
reoprt calling from form 11g
…all,
I have write this code on when button pressed it was working but now it is not working.
PROCEDURE Print_Report IS
MCUR_ITM VARCHAR2(40) := :SYSTEM.CURSOR_ITEM;
mpara varchar2(20) := :REPORTID;
server_name varchar2(100) := :…
|
| 4 |
Forum: Backup & Recovery «»
Posted on: Sun, 25 March 2018 22:23 «»
By: BlackSwan
Re: ORA-27072: File I/O error for sysaux.dbf, more logfiles than expected
…
select
relative_fno,
owner,
segment_name,
segment_type
from
dba_extents
where
file_id in (SELECT FILE_ID FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'SYSAUX')
and
105600 between block_id and block_id + blocks - 1…
|
| 5 |
Forum: JDeveloper, Java & XML «»
Posted on: Tue, 20 February 2018 12:47 «»
By: CMcKinstry
Re: Using IDE Database Connections in Java code
…Thanks, that doesn't use the named database connection (testConnection). I'd still have to use the JDBC string along with username and password.
E.g.:
Note:
The login variables have been set to null to secure the application. At this point in the …
|
| 6 |
Forum: Server Utilities «»
Posted on: Fri, 08 December 2017 12:18 «»
By: rocioperezn
loading data from twitter with sqlldr
…all,
I have some problems loading a twitter data from a csv, with some multiline records. I have 4 columns id_tweet,text,created_at, username .
When text is enclosed by " the register is multiline or has comas inside, I show you 3 examples, …
|
| 7 |
Forum: Server Utilities «»
Posted on: Tue, 29 August 2017 10:59 «»
By: BlackSwan
Re: IMP-00010: not a valid export file, header failed verification
…>i think it was created by exp
You think wrongly.
exp does NOT have any DIRECTORY= parameter
[oracle@vbgeneric ~]$ exp help=yes
Export: Release 12.2.0.1.0 - Production on Tue Aug 29 11:57:27 2017
Copyright (c) 1982, 2017, Oracle and/or …
|
| 8 |
Forum: Application Express, ORDS & MOD_PLSQL «»
Posted on: Mon, 02 January 2017 06:58 «»
By: apexmahfuj
Hide schema name,username and password from url
…Hi,
I have called a rdf report (10g) from an apex page by passing three parameters and its working.
My report runs without no error.
But what have I found that the whole information such as schema name,user_name,password are showing in the path…
|
| 9 |
Forum: Reports & Discoverer «»
Posted on: Fri, 11 September 2015 04:14 «»
By: limig
Re: Problem while running two reports consecutively
…Forms, the following is called:
RUN_REPORT_OBJECT_PROC(v_report_id, vch_rep_srv, 'PDF', CACHE, v_report_file_name, v_report_other, '/reports/rwservlet') ;
--[v_report_id = report_object; vch_rep_srv = report server; v_report_other = parameter list]
…
|
| 10 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Sun, 29 March 2015 11:28 «»
By: Michel Cadot
Re: Setting up Pro*C Pre compiler in Windows
…
First refer to Pro*C/C++ Programmer's Guide
Then there is nothing special to do.
Just be sure that ORACLE_HOME is set and PATH contains %ORACLE_HOME%\lib library.
Also add %OracleHome%\precomp\public in your include path.
Then the Pro*C call is …
|
| 11 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 05 March 2015 05:40 «»
By: Solomon Yakobson
Re: Writing a Hierarchical Query without using the connect by prior
…believe SYBASE same as MS SQL and Oracle support recursive subquery factoring:
SQL> with user_hierarchy as (
2 select userid, username, user_group, user_type, level as level_num
3 from users
4 start with userid…
|
| 12 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 04 March 2015 12:04 «»
By: sachinj
Writing a Hierarchical Query without using the connect by prior
…
--Table Creation Script
CREATE TABLE USERS
(
USERID INTEGER NOT NULL,
USERNAME VARCHAR2(255 BYTE) NOT NULL,
FULLNAME VARCHAR2(255 BYTE) NOT NULL,
USER_GROUP…
|
| 13 |
Forum: Reports & Discoverer «»
Posted on: Thu, 22 January 2015 02:55 «»
By: nickron
Re: Error while converting Reports from rdf to rep
Example----
rwconverter.sh userid=username/pw@db batch=yes source=paysliptest.rdf stype=rdffile dtype=repfile overwrite=yes compile_all=yes
|
| 14 |
Forum: Reports & Discoverer «»
Posted on: Thu, 22 January 2015 02:51 «»
By: nickron
Error while converting Reports from rdf to rep
…the following command:
rwconverter.sh userid=username/password batch=yes
source=$i stype=rdffile dtype=rdffile overwrite=yes
compile_all=yes
getting below error…
|
| 15 |
Forum: Server Administration «»
Posted on: Mon, 19 January 2015 12:46 «»
By: BlackSwan
Re: Slow databases on a Solaris server after flushing buffer cache of one database
…dbv against /u01/oradata/db1/system1.dbf
[oracle@localhost ~]$ dbv
DBVERIFY: Release 11.2.0.2.0 - Production on Mon Jan 19 10:45:44 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Keyword Description…
|
| 16 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 30 September 2014 15:12 «»
By: Bill B
Re: Help with pre 9i Join to ANSI standard
…about
SELECT table_t2.username,
table_t1.date,
table_t1.days,
table_t1.loginid
FROM TABLE_T1 CROSS JOIN TABLE_T2 CROSS JOIN TABLE_T3 CROSS JOIN TABLE_T4
WHERE ( ( ( ( ( (table_t1.statement = table_t2.…
|
| 17 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 30 September 2014 10:55 «»
By: cookiemonster
Re: Help with pre 9i Join to ANSI standard
…Ok, So Here's the issues:
1) Those brackets don't actually do anything useful, so you should just lose them.
2) You're mixing join styles - if you're using ANSI joins you should use them for all tables, so there should be an inner join for t1 and t2 …
|
| 18 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 30 September 2014 10:20 «»
By: sucheta
Re: Help with pre 9i Join to ANSI standard
…is my ANSI attempt and attempt to get it to the correct formatting, syntax, etc for all here to view. I see what everyone means about the + now. My mistake obviously. Apologies. Yes table_t3.alternateid is nullable.
SELECT table_t2.username…
|
| 19 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 30 September 2014 09:35 «»
By: sucheta
Re: Help with pre 9i Join to ANSI standard
…it is formatted. Looks worse to me but if others can read it better, so be it.
SELECT table_t2.username,
table_t1.date,
table_t1.days,
table_t1.loginid
FROM table_t1,
table_t2,
table_t3,
…
|
| 20 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 30 September 2014 09:22 «»
By: sucheta
Help with pre 9i Join to ANSI standard
…have been tasked with converting old style join to ANSI. I completed the task but the two queries return slightly different result sets. It seems I have done something incorrect and hope someone can show me the proper conversion? Thanks
Here is the …
|
| 21 |
Forum: Reports & Discoverer «»
Posted on: Sat, 27 September 2014 12:44 «»
By: shahzad-ul-hasan
Re: detail and summary report
…HOST('RWRUN60 MODULE=REPORT_PATH\REPORT_NAME USERID=USERNAME/PASSWORD OTHER_PARAMETERS...');
See one example below.
For mentioning username and password:
Actually while calling the report through command line it will ask for the user id and password…
|
| 22 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 13 June 2014 08:42 «»
By: somnathsikdar
Delete statement is taking long time. Please suggest.
…all,
Please find the below script. I have written the script. At the end of the script a delete statement is taking 45 minute to delete 21613600 records from a table. Can you please suggest how can I improve the performance…
|
| 23 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 23 April 2014 07:21 «»
By: EdStevens
Re: ORA-28002 error while connecting DB LINK
…cookiemonster said, the error means exactly what it says.
To explain a bit further and perhaps clarify your understanding ...
A database link connects to another database just like any other client process. If dbA has a link pointing to dbB, as …
|
| 24 |
Forum: General «»
Posted on: Mon, 31 March 2014 00:34 «»
By: kesavansundaram
Re: How to view current date audit records from DBA_AUDIT_TRAIL
…you Mike and every one who worked for me.
below works well for me now.
col "DBMS" for a15
col "Host Name" for a30
col "OS UserID" for a15
col "User Machine" for a18
col "Time(G)" for a36
col &…
|
| 25 |
Forum: General «»
Posted on: Sun, 30 March 2014 22:56 «»
By: BlackSwan
Re: How to view current date audit records from DBA_AUDIT_TRAIL
…
1* select to_char(logged,'YYYY-MM-DD') from SYSMAN.MGMT_JOB_STATE_CHANGES
SQL> /
TO_CHAR(LO
----------
2013-07-11
2013-07-12
2013-07-12
2013-07-12
2013-07-12
2013-07-11
2013-07-12
2013-07-12
2013-07-11
9 rows selected.
SQL>…
|
| 26 |
Forum: General «»
Posted on: Sun, 30 March 2014 22:52 «»
By: BlackSwan
Re: How to view current date audit records from DBA_AUDIT_TRAIL
…
select D.NAME "DBMS",
I.HOST_NAME "Host Name",
A.OS_USERNAME "OS UserID",
A.USERHOST "User Machine",
A.TIMESTAMP "Local Time",
A.EXTENDED_TIMESTAMP "Time(G)"…
|
| 27 |
Forum: General «»
Posted on: Sun, 30 March 2014 21:20 «»
By: kesavansundaram
How to view current date audit records from DBA_AUDIT_TRAIL
…Team,
How to view current date audit records from DBA_AUDIT_TRAIL ?
21:51:32 SQL> select to_char(sysdate,'Day dd-mon-yyyy:hh24:mi:ss') from dual;
TO_CHAR(SYSDATE,'DAYDD-MON-YYYY:HH24:MI:SS…
|
| 28 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 11 February 2014 01:21 «»
By: sarfraz_attari
Re: Error in PL/SQL Procedure using UTL_HTTP
…am still waiting for the solution of this problem
when I modified the code of my PL/SQL with this
[Code]
PROCEDURE expert_http IS
req UTL_HTTP.REQ;
resp UTL_HTTP.RESP;
name VARCHAR2(1024);
value VARCHAR2(1024);
url VARCHAR2(4000…
|
| 29 |
Forum: Forms «»
Posted on: Mon, 25 November 2013 00:00 «»
By: jyothilekshmir2006
Re: Hiding hostname, username and password in URL (10g)
GO TO CONFIGURATION FILE 'reports/conf/cgicmd.dat' . then create a variable like this
rep: userid=username/password@database %* then use this rep instead of username/pass@db in your url
THANKS
JYOTHI
|
| 30 |
Forum: Weblogic & Application Server «»
Posted on: Sat, 08 June 2013 02:37 «»
By: ranamirfan
Re: How to encrypte the form, report calling addresses Or hide the address
…Dear,
1- Set your REPORTS_PATH in Registry
D:\10gpayroll\reports;
2- Define your UserName & Password / Report Server Name / Desformat & destype in Your cgicmd.dat file.
usr: userid=PR/CAAPR2013@hpdb Server=…
|
| 31 |
Forum: Weblogic & Application Server «»
Posted on: Fri, 24 May 2013 02:16 «»
By: annu-agi
How to encrypte the form, report calling addresses Or hide the address
…all gurus and experts
I have a application developed and running on WLS server and Oracle Application server 10g. The development is on forms and report 10g and 11g as well. All are running fine, now i would like to encrypt the address calling from …
|
| 32 |
Forum: Server Administration «»
Posted on: Tue, 26 March 2013 18:01 «»
By: alan.kendall@nfl.com
Re: Comparing DB parameters
…have one that does it in one swoop.
ECSCDAS1S > @vp_sp_dblink
Enter value for remote_tns: cscdap1p
Enter value for local_tns: cscdas1s
Table ALAN_REMOTE created.
270 rows selected from ecscdap1p@cscdap1p.
270 rows inserted into …
|
| 33 |
Forum: General «»
Posted on: Sun, 24 March 2013 09:32 «»
By: Michel Cadot
Re: reading from AUD$ Tables causes the performance issue ?
…is correct I didn't check the view definition (I should). The best option is to directly query SYS.AUD$ and not DBA_AUDIT_TRAIL and add an index on SYS.AUD$.NTIMESTAMP# as TIMESTAMP# is no more used.
Don't forget the WITH part of my query:
ith …
|
| 34 |
Forum: Networking and Gateways «»
Posted on: Tue, 05 March 2013 07:59 «»
By: sakamboh
Re: ORA-02047: cannot join the distributed transaction in progress
…Guys i have resolved the issue but their is a drawback of this solution... can anyone help me with this... I have modified my triger and now its working fine... but if i rollback in oracle it doesnot rollback in SQL. Please check below.
create or …
|
| 35 |
Forum: Networking and Gateways «»
Posted on: Tue, 05 March 2013 07:15 «»
By: sakamboh
ORA-02047: cannot join the distributed transaction in progress
…All,
I am trying to create dblink from oracle11GR2@linux to sql using easysoft odbc driver.
DBlink is successfull, i am able to use insert statements in SQL.
I want to insert in SQL database table whenever their is a insert in Oracle Table,I have…
|
| 36 |
Forum: Forms «»
Posted on: Wed, 05 December 2012 02:51 «»
By: Akarsh
sql loader with forms
…am using oracle forms 10g on windows 7 32 bit.
i want to load data from oracle form to oracle database.
i have written the following code on Push Buttons When-Button-Pressed trigger.
declare
usid varchar2(10):= get_application_property(username…
|
| 37 |
Forum: Server Utilities «»
Posted on: Wed, 21 November 2012 06:40 «»
By: Littlefoot
Re: Restore Dump File Error
…shouldn't guess syntax. Original export and import. Short help:
M:\>imp help=y
Import: Release 11.2.0.2.0 - Production on Sri Stu 21 13:39:55 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
You can let …
|
| 38 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 25 October 2012 06:21 «»
By: monkey_suit
Re: Converting utl_http.read_text to PDF file
…Michel coupled with your advice and some stuff in the docs and the web i was able to come up with a solution. the only issue i get with this is that when i try to open the pdf it complains that the pdf is already open, when close adobe reader and open it …
|
| 39 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 25 October 2012 03:22 «»
By: monkey_suit
Re: Converting utl_http.read_text to PDF file
…
declare
lf_file utl_file.file_type;
lr_raw_data raw(32767);
lb_clob_response clob;
lh_http_request utl_http.req;
lh_http_response utl_http.resp;
ln_counter pls_integer := 0;
ln_substr_len…
|
| 40 |
Forum: Forms «»
Posted on: Sat, 20 October 2012 03:28 «»
By: hissam78
LOGIN USER FROM ONE CANVAS AND ACCESS SECOND CANVAS AS PER USER RIGHTS
…ALL,
- we have user id parameter.
can we update the parameter(:parameter.p_userid) before firing "WHEN NEW FORM INSTANCE TRIGGER"(when new form instance trigger contain code for tree node), for login another
canvas as per user rights?
- i …
|
Blog
Search
Help
Members
Register
Login
Home